 CREATE EXTERNAL TABLE jms_dwd.dwd_tab_barscan_business_base_hi(
  `recordid` string COMMENT '记录编号',
  `billcode` string COMMENT '运单号',
  `scantype` string COMMENT '扫描类型',
  `scanuser` string COMMENT '扫描雇员',
  `inputsite` string COMMENT '录入部门',
  `scantime` timestamp COMMENT '扫描时间',
  `send_deliver_user` string COMMENT '派件或收件员',
  `scansitecode` string COMMENT '扫描网点编号',
  `uploadtime` timestamp COMMENT '上传时间',
  `scanusercode` string COMMENT '扫描雇员编号',
  `send_deliver_usercode` string COMMENT '收派员编号',
  `source` string,
  `scansiteid` bigint COMMENT '扫描网点id',
  `nextstationid` bigint COMMENT '上/下一站网点id',
  `nextstationcode` string COMMENT '上/下一站网点code',
  `nextstation` string COMMENT '上/下一站网点名称',
  TRACEPUSHED int comment ' 1:代表 (真实/虚拟)轨迹已经推送过不用推送, 其他空或0的表示需要正常推送')
COMMENT '商务件-扫描轨迹来源jms导入'
PARTITIONED BY (
  `dt` string COMMENT '（yyyy-MM-dd-HH）')
stored as parquet
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_tab_barscan_business_base_hi';